---
title: "SP72347_INFO_PAGE_PRINTED_YN stored procedure documentation"
summary: "Analysis of the SP72347_INFO_PAGE_PRINTED_YN Oracle function including business rules and operations."
status: draft
owner: "SAIF Corporation"
last_reviewed: 2026-08-31
source_schema: "WCIS_DBA"
source_name: "SP72347_INFO_PAGE_PRINTED_YN"
source_type: "PROCEDURE"
retrieval_status: "found"
retrieval_command: "legends oracle query --name SP72347_INFO_PAGE_PRINTED_YN"
retrieval_date: "2026-08-31"
---

# SP72347_INFO_PAGE_PRINTED_YN

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Type** | Standalone function |
| **Database** | Oracle |
| **Status** | ✅ `found` — retrieved via Legends CLI |
| **Query executed** | `legends oracle query --name SP72347_INFO_PAGE_PRINTED_YN` |
| **Calling libraries** | `SAIF.Business.View.Policy` |
| **Calling classes** | `clsPolicyData` |

## Purpose

`SP72347_INFO_PAGE_PRINTED_YN` returns a `Y`/`N` flag indicating whether the information page has
printed for a policy period.

## Procedures / Methods

### SP72347_INFO_PAGE_PRINTED_YN

| Field | Value |
| --- | --- |
| **Returns** | `CHAR` (function return value) |
| **Called by** | `clsPolicyData.IsInformationPagePrinted` (`clsPolicyData.vb:1772-1792`, SQL at `2332`) |

**Description:** Delegates the information-page-printed decision to `sp72253_info_page_printed` (out
of catalog scope, not retrieved separately) and surfaces unhandled errors as an application error (see
rules PR-BVP-013, PR-BVP-014 in [Business Rules](#business-rules) below).

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number |
| `in_policy_period_eff_date` | IN | `DATE` | — | Period effective date |
| *(return)* | RETURN | `CHAR(1)` | — | `Y` / `N` |

## Business Rules

Rules extracted from this function's logic:

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PR-BVP-013 | Information-page printed indicator is delegated to `sp72253_info_page_printed` | wrapped check returns true | Return `'Y'`; otherwise `'N'` |
| PR-BVP-014 | Unhandled errors are surfaced as an application error | `EXCEPTION WHEN others` | `RAISE_APPLICATION_ERROR(-20002, 'Error in sp72347: ' \|\| SQLERRM)` |

> These rules are documented in [business-rules.md](../business-rules.md).

## Operations

Operations and processes implemented in this function:

| Operation | Description | Trigger |
| --- | --- | --- |
| Check information page printed | Returns `Y`/`N` indicating whether the information page has printed | `clsPolicyData.IsInformationPagePrinted` (`clsPolicyData.vb:1772-1792`, SQL at `2332`) |

> These operations are also listed in [operations-processes.md](../operations-processes.md) with source reference back to this document.

## Source Code

<details>
<summary>PL/SQL function (specification and body)</summary>

```sql
FUNCTION SP72347_INFO_PAGE_PRINTED_YN (in_policy_num             IN NUMBER,
                                       in_policy_period_eff_date IN DATE)
   RETURN CHAR
IS
BEGIN
   -- wrapper over sp72253_info_page_printed
   IF sp72253_info_page_printed (in_policy_num, in_policy_period_eff_date)
   THEN
      RETURN 'Y';
   ELSE
      RETURN 'N';
   END IF;
EXCEPTION
   WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR (-20002, 'Error in sp72347: ' || SQLERRM);
END;
```

</details>

## Related Documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

## Sources
- Oracle DBA_SOURCE: `WCIS_DBA.SP72347_INFO_PAGE_PRINTED_YN`
- Legends CLI query executed 2026-08-31: `legends oracle query --name SP72347_INFO_PAGE_PRINTED_YN`
- Calling code: `SAIF.Business.View.Policy/clsPolicyData.vb:1772-1792, 2332`